Release 10.1A: OpenEdge Data Management:
Database Administration

OpenEdge virtual system table schema descriptions

Table 25–2 through Table 25–43 describe the schema for each virtual system table.

Table 25–2: After-image log activity file (_ActAILog) 

Record	Description
_AiLog-AIWWrites	Number of after-image writes performed by the after-image writer (AIW). This is a subset of the total number of AI writes.
_AiLog-BBuffWaits	Number of busy buffer waits.
_AiLog-BytesWritn	Amount of AI data written to the AI file, in bytes.
_AiLog-ForceWaits	Number of waiting-for-commit records to be written to disk.
_AiLog-NoBufAvail	Total number of times a process had to wait because a buffer was not available.
_AiLog-PartialWrt	Number of writes to the AI file made before the AI buffer is full.
_AiLog-RecWriten	Number of records written to the AI file.
_AiLog-TotWrites	Total number of writes to the AI file.
_AiLog-Trans	Number of transactions committed to the AI file.
_AiLog-UpTime	Number of seconds the AI file was open.

Table 25–3: Before-image log activity file (_ActBILog)

Record	Description
_BiLog-BBuffWaits	Number of times a process had to wait for a buffer that was busy.
_BiLog-BIWWrites	Number of writes to the BI file performed by the before-image writer (BIW). For good performance, this number should be high in relation to the total number of BI writes.
_BiLog-BytesRead	Number of bytes of data read from the BI file.
_BiLog-BytesWrtn	Number of bytes of data written to the BI file.
_BiLog-ClstrClose	Number of BI clusters filled and closed in preparation for reuse.
_BiLog-EBuffWaits	Number of times a process had to wait because all buffers were full.
_BiLog-ForceWaits	Number of waiting-for-commit records to be written to disk.
_BiLog-ForceWrts	Number of waiting-for-commit records written to disk.
_BiLog-PartialWrts	Number of writes to the BI file made before the BI buffer is full.
_BiLog-RecRead	Number of BI records (notes) read from the BI file.
_BiLog-RecWriten	Number of BI records (notes) written to the BI file.
_BiLog-TotalWrts	Number of total writes to the BI file.
_BiLog-TotReads	Number of BI blocks read from the BI file to undo transactions.
_BiLog-Trans	Number of transactions committed to the BI file.
_BiLog-UpTime	Number of seconds the BI file was open.

Table 25–4: Buffer activity file (_ActBuffer)

Record	Description
_Buffer-APWEnq	Number of modified buffers placed on the APW queue for writing.
_Buffer-Chkpts	Number of checkpoint operations.
_Buffer-Deferred	Total number of changes to blocks that occurred before the blocks were written. Each deferred write is potentially an I/O operation saved.
_Buffer-Flushed	Number of blocks that were not written during the checkpoint and that had to be written all at once at the end of the checkpoint.
_Buffer-LogicRds	Number of client requests for database block read operations.
_Buffer-LogicWrts	Number of client requests for database block write operations.
_Buffer-LRUSkips	Number of times a buffer on the LRU chain was skipped because it was locked or modified.
_Buffer-LRUwrts	Number of blocks written to free a buffer for a read operation.
_Buffer-Marked	Number of blocks scheduled to be written before the end of a checkpoint.
_Buffer-OSRds	Number of database blocks read from disk.
_Buffer-OSWrts	Number of database block writes to disk.
_Buffer-Trans	Number of transactions committed.
_Buffer-Uptime	Number of seconds the database was opened.

Table 25–5: Index activity file (_ActIndex) 

Record	Description
_Index-Create	Number of new index entries generated.
_Index-Delete	Number of index entries deleted.
_Index-Find	Number of times an index entry was looked up.
_Index-Free	Number of index blocks freed during deletes.
_Index-Remove	Number of locks released at transaction end.
_Index-Splits	Number of block splits resulting from index additions.
_Index-Trans	Number of transactions committed.
_Index-UpTime	Number of seconds the database was up.

Table 25–6: Input/output activity file (_ActIOFile)

Record	Description
_IOFile-BufReads	Number of buffered read operations performed on the file.
_IOFile-BufWrites	Number of buffered write operations performed on the file.
_IOFile-Extends	Number of extend operations performed on the file.
_IOFile-FileName	Name of the file upon which operations are performed.
_IOFile-Reads	Number of read operations performed on the file.
_IOFile-Trans	Number of transactions committed.
_IOFile-UbufReads	Number of unbuffered read operations performed on the file.
_IOFile-UbufWrites	Number of unbuffered write operations performed on the file.
_IOFile-UpTime	Number of seconds the database was up.
_IOFile-Writes	Number of write operations performed on the file.

Table 25–7: Input/output type activity file (_ActIOType)

Record	Description
_IOType-AiRds	Number of AI read operations.
_IOType-AiWrts	Number of AI write operations.
_IOType-BiRds	Number of BI read operations.
_IOType-BiWrts	Number of BI write operations.
_IOType-DataReads	Number of reads of data blocks.
_IOType-DataWrts	Number of writes to data blocks.
_IOType-IdxRds	Number of reads of index blocks.
_IOType-IdxWrts	Number of writes to index blocks.
_IOType-Trans	Number of transactions committed.
_IOType-UpTime	Number of seconds the database was up.

Table 25–8: Lock table activity file (_ActLock)

Record	Description
_Lock-CanclReq	Number of lock requests that were cancelled.
_Lock-Downgrade	Number of locks that were downgraded.
_Lock-ExclFind	Number of exclusive find requests granted.
_Lock-ExclLock	Number of exclusive lock requests.
_Lock-ExclReq	Number of requests for exclusive locks granted.
_Lock-ExclWait	Number of times processes waited for an exclusive lock.
_Lock-RecGetLock	Number of requests for record get locks granted.
_Lock-RecGetReq	Number of record get locks granted.
_Lock-RecGetWait	Number of times processes waited for record gets.
_Lock-RedReq	Number of duplicate requests granted.
_Lock-ShrFind	Number of share find requests granted.
_Lock-ShrLock	Number of share lock requests granted.
_Lock-ShrReq	Number of requests for share locks.
_Lock-ShrWait	Number of times processes waited for share lock.
_Lock-Trans	Number of transactions committed.
_Lock-UpgLock	Number of requests for lock upgrades granted.
_Lock-UpgReq	Number of requests to upgrade a lock from shared lock to exclusive lock.
_Lock-UpgWait	Number of times processes waited for upgrades.
_Lock-UpTime	Number of seconds the database was up.

Table 25–9: Other activity file (_ActOther) 

Record	Description
_Other-Commit	Number of transactions committed.
_Other-FlushMblk	Number of times the database master block was written to disk.
_Other-Trans	Transactions committed.
_Other-Undo	Number of transactions rolled back.
_Other-UpTime	Number of seconds the database was up.
_Other-Wait	Number of times a process had to wait for a resource.

Table 25–10: Page writer activity file (_ActPWs)

Record	Description
_PW-ApwQWrites	Number of buffers written to clear the APW queue.
_PW-BuffsScaned	Number of buffers scanned during each cycle.
_PW-BufsCkp	Number of buffers checkpointed.
_PW-Checkpoints	Number of checkpoints that have occurred.
_PW-CkpQWrites	Number of buffers written from the checkpoint queue.
_PW-DBWrites	Number of database write operations performed by the APW.
_PW-Flushed	Number of blocks that were not written during the checkpoint and had to be written all at once at the end of the checkpoint.
_PW-Marked	Number of buffers that were scheduled to be written before the end of the checkpoint.
_PW-ScanCycles	Number of scan cycles. During a scan cycle, the APW scans a portion of the buffer pool to look for modified buffers.
_PW-ScanWrites	Number of buffers written during the scan cycle.
_PW-TotDBWrites	Total number of database write operations performed by all processes.
_PW-Trans	Number of transactions committed.
_PW-UpTime	Number of seconds the database was up.

Table 25–11: Record activity file (_ActRecord)

Record	Description
_Record-BytesCreat	Number of bytes created.
_Record-BytesDel	Number of bytes deleted.
_Record-BytesRead	Number of bytes read.
_Record-BytesUpd	Number of bytes updated.
_Record-FragCreat	Number of fragments created.
_Record-FragDel	Number of fragments deleted.
_Record-FragRead	Number of fragments read.
_Record-FragUpd	Number of fragments updated.
_Record-RecCreat	Number of records created.
_Record-RecDel	Number of records deleted.
_Record-RecRead	Number of records read.
_Record-RecUpd	Number of records updated.
_Record-Trans	Number of transactions committed.
_Record-UpTime	Number of seconds the database was up.

Table 25–12: Server activity file (_ActServer)

Record	Description
_Server-ByteRec	Number of bytes received by the server.
_Server-ByteSent	Number of bytes sent by the server.
_Server-MsgRec	Number of network packets received by the server.
_Server-MsgSent	Number of network packets sent by the server.
_Server-QryRec	Number of query requests received.
_Server-RecRec	Number of records received.
_Server-RecSent	Number of records sent.
_Server-TimeSlice	Number of query time slice switches.
_Server-Trans	Number of transactions committed.
_Server-UpTime	Number of seconds the database was up.

Table 25–13: Space allocation activity file (_ActSpace)

Record	Description
_Space-AllocNewRm	Number of times space was allocated for a record or record fragment.
_Space-BackAdd	Number of blocks added to the back of the rm chain.
_Space-BytesAlloc	Number of bytes allocated for record fragments.
_Space-DbExd	Number of times the database was extended.
_Space-Examined	Number of blocks examined in the rm chain while looking for space for a record fragment.
_Space-FromFree	Number of times space was allocated from the free chain.
_Space-FromRm	Number of times space was allocated from the rm chain.
_Space-Front2Back	Number of blocks moved from the front to the back of the rm chain.
_Space-FrontAdd	Number of blocks added to the front of the rm chain.
_Space-Locked	Number of locked rm entries removed.
_Space-Removed	Number of blocks removed from the rm chain.
_Space-RetFree	Number of times a block was returned to the free chain.
_Space-TakeFree	Number of times a block was used from the free chain.
_Space-Trans	Number of transactions committed.
_Space-UpTime	Number of seconds the database was up.

Table 25–14: Summary activity file (_ActSummary)

Record	Description
_Summary-AiWrites	Number of AI blocks written to disk.
_Summary-BiReads	Number of BI blocks read.
_Summary-BiWrites	Number of BI blocks written to disk.
_Summary-Chkpts	Number of checkpoints that have been performed.
_Summary-Commits	Number of transactions all users have committed.
_Summary-DbAccesses	Number of times users have waited for shared and exclusive locks on a database buffer.
_Summary-DbReads	Number of database blocks read.
_Summary-DbWrites	Number of database blocks written to disk.
_Summary-Flushed	Number of database buffers that have been flushed to disk because they were not written by the time the checkpoint ended.
_Summary-RecCreat	Number of records created.
_Summary-RecDel	Number of records deleted.
_Summary-RecLock	Number of record locks used.
_Summary-RecReads	Number of records read.
_Summary-RecUpd	Number of records updated.
_Summary-RecWait	Number of times users have waited to access a locked record.
_Summary-TransComm	Number of transactions committed.
_Summary-Undos	Number of transactions rolled back.
_Summary-Uptime	Number of seconds the database was up.

Table 25–15: Area status file (_AreaStatus) 

Record	Description
_AreaStatus-Areanum	Area number.
_AreaStatus-Areaname	Area name.
_AreaStatus-Totblocks	Total number of blocks in an area.
_AreaStatus-Hiwater	Highest block used.
_AreaStatus-Extents	Number of extents in an area.
_AreaStatus-Lastextent	Name of extent where high-water mark resides.
_AreaStatus-Freenum	Number of blocks on the free chain.
_AreaStatus-Rmnum	Number of blocks on the rm chain.

Table 25–16: Block file (_Block)

Record	Description
_Block-Area	Block area number.
_Block-BkupCtr	Backup counter.
_Block-Block	Data section of the block.
_Block-ChainType	Chain type.
_Block-Dbkey	Dbkey.
_Block-NextDbkey	Next Dbkey in the appropriate chain.
_Block-Type	Type of block.
_Block-Update	Number of times the block has been updated.

Table 25–17: Buffer status file (_BuffStatus) 

Record	Description
_BfStatus-APWQ	Number of buffers on the page writer queue.
_BfStatus-CKPMarked	Number of buffers currently marked for checkpoint.
_BfStatus-CKPQ	Number of buffers on the checkpoint queue.
_BfStatus-HashSize	Size of the buffer hash table.
_BfStatus-LastCkpNum	Most recent checkpoint number. As checkpoints begin, they are assigned a sequential number from the start of the session. The number is also the number of checkpoints that have occurred.
_BfStatus-LRU	Number of buffers on the least recently used (LRU) chain.
_BfStatus-ModBuffs	Number of dirty (modified) buffers.
_BfStatus-TotBufs	Number of buffers in the buffer cache.
_BfStatus-UsedBuffs	Number of buffers used.

Table 25–18: Checkpoint File (_Checkpoint) 

Record	Description
_Checkpoint-ApwQ	Number of blocks written by the APW queue and replaced on the least recently used (LRU) chain by APWs.
_Checkpoint-CptQ	Number of blocks written from the checkpoint queue by the APWs.
_Checkpoint-Dirty	Number of modified blocks scheduled to be written.
_Checkpoint-Flush	Total number of blocks not written during the checkpoint that had to be written all at once at the end of the checkpoint.
_Checkpoint-Len	Length of time required to complete the checkpoint.
_Checkpoint-Scan	Number of blocks written by the APWs during the scan cycle.
_Checkpoint-Time	Time the checkpoint began.

Table 25–19: Code Features (_Code-Feature) 

Field name	Data type	Description
_CodeFeature_Name	Character	Name of the database feature.
_CodeFeature_Supported	Character	“1” indicates the code supports this database feature. “0” indicates the code does not support this feature.
_CodeFeature_Required	Character	“1” indicates this feature is required to be active in any database this code opens. “0” indicates the database does not require this feature to be active.
_CodeFeature-Res01	Character	Reserved for future use.
_CodeFeature-Res02	Integer	Reserved for future use.

Table 25–20: Database connection file (_Connect) 

Record	Description
_Connect-2phase	Displays a two-phase commit flag, either “yes” or “no.”
_Connect-Batch	Displays batch users status.
_Connect-Device	Device from which the user has connected to the database.
_Connect-Disconnect	Displays a disconnect flag.
_Connect-Interrupt	Displays an interrupt flag.
_Connect-Name	Displays the user name used for the connection.
_Connect-Pid	Displays the process ID of the user session.
_Connect-Resync	Displays a flag that indicates the database is resyncing.
_Connect-SemId	Displays the semaphore ID.
_Connect-SemNum	Displays the semaphore number.
_Connect-Server	Identifies the server if the connection is remote.
_Connect-Time	Time the user connected to the database.
_Connect-transId	Displays the current transaction ID.
_Connect-Type	Displays the connection type: SELF, REMC, BROK, SERV, or BTCH.
_Connect-Usr	Displays the user number.
_Connect-Wait	Displays the shared memory resource the user is waiting on.
_Connect-Wait1	Displays additional wait flags.

Table 25–21: Database features (_Database-Feature) 

Field Name	Data Type	Description
_DBFeature_Name	Character	Name of the database feature.
_DBFeature_Enabled	Character	“1” indicates the feature is enabled. “0” indicates the feature is not enabled.
_DBFeature_Active	Character	“1” indicates this feature is active within the database. “0” indicates this feature is not active.
DBFeature-Res01	Character	Reserved for future use.
DBFeature-Res02	Integer	Reserved for future use.

Table 25–22: Database status file (_DbStatus)

Record	Description
_DbStatus-AiBlkSize	Number of bytes in an after-image block.
_DbStatus-BiBlkSize	Number of bytes in a before-image block.
_DbStatus-BiClSize	Number of kilobytes in the before-image cluster.
_DbStatus-BiOpen	Most recent BI file open.
_DbStatus-BiSize	Logical size of the BI file. You can use this in conjunction with the _DbStatus-BiClSize value to determine the number of clusters in the BI file.
_DbStatus-BiTrunc	Time since the last truncate.
_DbStatus-CacheStamp	Schema cache file time stamp.
_DbStatus-Changed	Flag indicating if database has changed since last backup.
_DbStatus-ClVersMinor	Client minor version number.
_DbStatus-Codepage	The value in this field is not maintained. This field will be removed in a future release.
_DbStatus-Collation	The value in this field is not maintained. This field will be removed in a future release.
_DbStatus-CreateDate	Date and time of database creation.
_DbStatus-DbBlkSize	Database block size.
_DbStatus-DbVers	Database version number.
_DbStatus-DbVersMinor	Database minor version number.
_DbStatus-EmptyBlks	Number of empty blocks in the database.
_DbStatus-FbDate	Most recent full backup.
_DbStatus-FreeBlks	Number of free blocks in the database.
_DbStatus-HiWater	Database blocks high-water mark.
_DbStatus-IbDate	Most recent incremental backup.
_DbStatus-IbSeq	Sequence of last incremental backup.
_DbStatus-Integrity	DbStatus-Integrity enabled flag (-i).
_DbStatus-IntFlags	Integrity flags.
_DbStatus-LastOpen	Most recent database open.
_DbStatus-LastTable	Highest table number defined.
_DbStatus-LastTran	Last transaction ID.
_DbStatus-MostLocks	Lock table high-water mark.
_DbStatus-NumAreas	Number of areas.
_DbStatus-NumLocks	Lock table entries in use.
_DbStatus-NumSems	Number of semaphores.
_DbStatus-PrevOpen	Previous database open.
_DbStatus-RMFreeBlks	Number of rm blocks with free space.
_DbStatus-SharedMemVer	Shared memory version number.
_DbStatus-ShmVers	Shared memory version number.
_DbStatus-Starttime	Time when the database was started.
_DbStatus-State	State of the database.
_DbStatus-Tainted	Damaged database flags.
_DbStatus-TotalBlks	Number of blocks allocated to the database.

Table 25–23: Database file status file (_Filelist) 

Record	Description
_FileList-BlkSize	Block size of the file.
_FileList-Extend	Amount of most recent extend in blocks.
_FileList-LogicalSz	Logical file size, in blocks.
_FileList-Name	Name of the file.
_FileList-Openmode	Displays the mode in which the file is opened.
_FileList-Size	Size of the file.

Table 25–24: Index statistics file (_IndexStat)

Record	Description
_IndexStat-Blockdelete	Number of block deletes that have occurred to the index.
_IndexStat-Delete	Number of times delete access has occurred to the index.
_IndexStat-Create	Number of times create access has occurred to the index.
_IndexStat-Read	Number of times read access has occurred to the index.
_IndexStat-Split	Number of split operations that have occurred to the index.

Table 25–25: Latch statistics file (_Latch) 

Record	Description
_Latch-Busy	Latch busy count.
_Latch-Hold	User number of the last latch holder.
_Latch-Lock	Latch lock count.
_Latch-LockedT	Used for calculation of duration of lock.
_Latch-LockT	Number, in microseconds, the latch was locked.
_Latch-Name	Latch name.
_Latch-Qhold	User number of the last queue holder.
_Latch-Spin	Latch spin count.
_Latch-Type	Latch type.
_Latch-Wait	Latch wait (nap) count.
_Latch-WaitT	Number, in microseconds, of wait or spin time.

Table 25–26: License management (_License) 

Record	Description
_Lic-ActiveConns	Number of active connections.
_Lic-BatchConns	Number of current batch connections.
_Lic-CurrConns	Number of current connections.
_Lic-MaxActive	Maximum number of active connections.
_Lic-MaxBatch	Maximum number of batch connections.
_Lic-MaxCurrent	Maximum number of current connections.
_Lic-MinActive	Minimum number of active users.
_Lic-MinBatch	Minimum number of batch connections.
_Lic-MinCurrent	Minimum number of current connections.
_Lic-ValidUsers	Number of valid license users.

Table 25–27: Lock table status file (_Lock) 

Record	Description
_Lock-Chain	Chain number.
_Lock-Flags	Flags for the lock. The flags specify a share lock (S), exclusive lock (X), a lock upgraded from share to exclusive (U), a lock in limbo (L), or a queued lock (Q).
_Lock-Name	User name.
_Lock-RecId	RECID of the record and lock table entry.
_Lock-Table	Table name.
_Lock-Type	Type of lock (for example, REC, RGET).
_Lock-Usr	User number of the user who owns the lock entry.

Table 25–28: Lock request file (_LockReq) 

Record	Description
_LockReq-ExclFind	Number of exclusive lock finds acquired by the user.
_LockReq-Name	User name.
_LockReq-Num	User number.
_LockReq-RecLock	Number of record locks acquired by the user.
_LockReq-RecWait	Number of times the user had to wait for a record lock.
_LockReq-SchLock	Number of schema locks acquired by the user.
_LockReq-SchWait	Number of times the user had to wait for a schema lock.
_LockReq-ShrFind	Number of share lock finds acquired by the user.
_LockReq-TrnLock	Number of transaction locks acquired by the user.
_LockReq-TrnWait	Number of times the user had to wait for a transaction lock.

Table 25–29: Logging file (_Logging)

Record	Description
_Logging-2PC	“Yes” indicates that two-phase commit is enabled; “No” indicates that two-phase commit is disabled.
_Logging-2PCNickName	Nickname used to identify the coordinator database. You specify a nickname when you enable two-phase commit.
_Logging-2PCPriority	Priority for the coordinator database. You specify the priority when you enable two-phase commit.
_Logging-AiBegin	Date of the last AIMAGE BEGIN command.
_Logging-AiBlkSize	Size of the after-image block. You can change the AI block size. This reduces I/O rates on disks that have AI files.
_Logging-AiBuffs	Number of buffers in the AI buffer pool. You can change the number of AI buffers with the After-image Buffers (-aibufs) startup parameter. The default value is 1.
_Logging-AiCurrExt	Current after-image extent.
_Logging-AiExtents	Number of AI files or extents.
_Logging-AiGenNum	Generation number of the current AI extent.
_Logging-AiIO	After-image I/O. “Reliable” indicates that synchronous or direct I/O is being used for AI writes. “Buffered” indicates that buffered I/O is being used for AI writes.
_Logging-AiJournal	“YES” indicates that after-imaging is enabled; “NO” indicates that after-imaging is disabled.
_Logging-AiLogSize	Number of kilobytes in the AI log file, if the AI extent in use is variable length. If the AI extent in use is fixed length, the value is 0.
_Logging-AiNew	Date of the last AIMAGE NEW command.
_Logging-AiOpen	Date when the AI log was last opened.
_Logging-BiBlkSize	BI block size.
_Logging-BiBuffs	Number of BI buffers.
_Logging-BiBytesFree	Number of free bytes remaining in the current BI cluster.
_Logging-BiClAge	Period of time that must pass before a BI cluster is reused. This period ensures that database blocks flushed at checkpoint are moved from the UNIX buffers on disk. When this occurs, the transaction is durably recorded on disk.
_Logging-BiClSize	BI cluster size.
_Logging-BiExtents	Number of BI extents.
_Logging-BiFullBuffs	Number of full BI buffers.
_Logging-BiIO	One of the following: “Reliable” indicates that synchronous or direct I/O is being used for BI writes; “BUFFERED” indicates that buffered I/O is being used for BI writes.
_Logging-BiLogSize	Number of kilobytes in the BI file.
_Logging-CommitDelay	Current value of the Delayed BI File Write (-Mf) parameter.
_Logging-CrashProt	“Yes” indicates that crash protection is enabled; “No” indicates that crash protection is disabled.
_Logging-LastCkp	Time of the last checkpoint.

Table 25–30: Master block file (_MstrBlk)

Record	Description
_MstrBlk-AiBlksize	Number of bytes in an AI block.
_MstrBlk-BiBlksize	Number of bytes in a BI block.
_MstrBlk-BiOpen	Date and time the BI file was last opened.
_MstrBlk-BiPrev	Previous value of _MstrBlk-biopen.
_MstrBlk-BiState	Current state of BI file.
_MstrBlk-Cfilnum	Highest file number currently defined in the database.
_MstrBlk-Crdate	Date and time of database creation.
_MstrBlk-Dbstate	Current state of the database.
_MstrBlk-Dbvers	Database version number.
_MstrBlk-Fbdate	Date and time of the last full backup.
_MstrBlk-Hiwater	Database blocks high-water mark.
_MstrBlk-Ibdate	Date and time of most recent incremental backup.
_MstrBlk-Ibseq	Sequence of last incremental backup.
_MstrBlk-Integrity	Database integrity enabled flag.
_MstrBlk-Lasttask	Last transaction ID.
_MstrBlk-Oppdate	Date and time of previous database open.
_MstrBlk-Oprdate	Date and time of most recent database open.
_MstrBlk-Rlclsize	Current BI cluster size.
_MstrBlk-Rltime	Time since last before-image file truncate.
_MstrBlk-Tainted	Database damaged flags.
_MstrBlk-Timestamp	Schema cache file time stamp.
_MstrBlk-Totblks	Number of blocks allocated to the database.

Table 25–31: User connection (_MyConnection) 

Record	Description
_MyConn-NumSeqBuffers	Number of private read-only buffers currently allowed.
_MyConn-Pid	The user’s process ID.
_MyConn-UsedSeqBuffers	Number of private read-only buffers currently in use.
_MyConn-UserId	The user’s user number.

Table 25–32: Resource queue statistics file (_Resrc) 

Record	Description
_Resrc-Name	Resource queue name.
_Resrc-Lock	Resource queue lock count.
_Resrc-Wait	Resource queue wait count.
_Resrc-Time	Resource queue wait time.

Table 25–33: Segments file (_Segments) 

Record	Description
_Segment-ByteFree	Number of free bytes in this shared memory segment.
_Segment-BytesUsed	Number of bytes used in this shared memory segment.
_Segments-Segld	Segment ID.
_Segments-SegSize	Segment size.

Table 25–34: Servers file (_Servers) 

Record	Description
_Server-CurrUsers	Number of current users connected to this server.
_Server-Logins	Number of established logins.
_Server-MaxUsers	Maximum number of logins available on the server.
_Server-Num	Server number.
_Server-Pid	Process ID of the server.
_Server-PortNum	TCP/IP port number of the server.
_Server-Protocol	Protocol supported by the server.
_Server-Type	Server type.

Table 25–35: Startup file (_Startup)

Record	Description
_Startup-AiBuffs	Number of after-image buffers.
_Startup-AiName	Value of the After-image Filename (-a) startup parameter.
_Startup-APWBuffs	Value of the Page Writer Scan (-pwscan) parameter.
_Startup-APWMaxWrites	Value of the Page Writer Maximum Buffers (-pwwmax) startup parameter.
_Startup-APWQTime	Value of the Page Writer Queue Delay (-pwqdelay) startup parameter.
_Startup-APWSTime	Value of the Page Writer Scan Delay (-pwsdelay) parameter.
_Startup-BiBuffs	Number of before-image buffers.
_Startup-BiDelay	Delay of before-image flush (-mf).
_Startup-BiIO	Before-image file I/O (-r, -R).
_Startup-BiName	Before-image filename (-g).
_Startup-BiTrunc	Before-image truncate interval (-G).
_Startup-Buffs	Number of database buffers (-B).
_Startup-CrashProt	No crash protection (-i).
_Startup-Directio	Direct I/O data transfer (-directio). Field is set to 1 when -directio is specified.
_Startup-LockTable	Maximum size of the locking table.
_Startup-MaxClients	Value of the Maximum Clients per Server (-Ma) startup parameter.
_Startup-MaxServers	Value of the Maximum Servers (-Mn) startup parameter.
_Startup-MaxUsers	Value of the Maximum Users (-n) startup parameter.
_Startup-Spin	Number of spinlock tries before time-out occurs.

Table 25–36: Index and table statistics range (_StatBase) 

Record	Description
_IndexBase	Index statistics base.
_TableBase	Table statistics base.

Table 25–37: Table statistics file (_TableStat) 

Record	Description
_TableStat-Create	Number of times create access has occurred to the table.
_TableStat-Delete	Number of times delete access has occurred to the table.
_TableStat-Read	Number of times read access has occurred to the table.
_TableStat-Update	Number of times update access has occurred to the table.

Table 25–38: Transaction file (_Trans) 

Record	Description
_Trans-Coord	Name of the coordinator database.
_Trans-CoordTx	Current coordinator transaction number.
_Trans-Counter	Transaction count.
_Trans-Duration	Number of seconds the transaction required to complete.
_Trans-Flags	Transaction flags.
_Trans-Misc	Miscellaneous information.
_Trans-Num	Transaction number.
_Trans-State	Transaction state.
_Trans-Txtime	Transaction start time.
_Trans-Usrnum	User number of the user running the distributed transaction.

Table 25–39: Transaction end lock statistics (_TxeLock) 

Record	Description
_Txe-Locks	Total number of times that transaction end lock is requested.
_Txe-Lockss	Number of concurrently held locks. (Only valid for update and commit locks.)
_Txe-Time	Not yet implemented. Always “?.”
_Txe-Type	Type of transaction end lock, such as update or commit.
_Txe-Waits	Number of times a transaction end lock request has been queued; how many times you had to wait.
_Txe-Waitss	Number of concurrently queued locks. (Only valid for update and commit locks.)
_Txe-Wait-Time	Not yet implemented. Always “?.”

Table 25–40: Database input/output file (_UserIO)

Record	Description
_UserIO-AiRead	Number of AI read operations performed by the process.
_UserIO-AiWrite	Number of AI write operations performed by the process.
_UserIO-BiRead	Number of BI read operations performed by the process.
_UserIO-BiWrite	Number of BI write operations performed by the process.
_UserIO-DbAccess	Number of database access operations performed by the process.
_UserIO-DbRead	Number of database read operations performed by the process.
_UserIO-DbWrite	Number of database write operations performed by the process.
_UserIO-Name	User name of the process.
_UserIO-Usr	User number of the process.

Table 25–41: Record locking table file (_UserLock) 

Record	Description
_UserLock-Chain	Type of chain should always be REC, the record lock chain.
_UserLock-Flags	Any of four possible types of flags: L (LIMBO lock), P (PURGED lock entry), Q (QUEUED lock request), and U (UPGRADE request).
_UserLock-Misc	Miscellaneous information.
_UserLock-Name	User name of the process owning the lock.
_UserLock-Recid	Record ID for the record being locked.
_UserLock-Type	One of the three lock types: EXCL (EXCLUSIVE-LOCK), SHR (SHARE-LOCK), or NOLK (NO-LOCK).
_UserLock-Usr	User number of the process owning the lock.

Table 25–42: User status (_UserStatus)

Record	Description
_UserStatus-Counter	Count blocks accessed, records moved, tables moved, or indexes compacted, etc.
_UserStatus-ObjectId	The table or index worked on.
_UserStatus-ObjectType	The type of object worked on.
_UserStatus-Operation	Name of the online utility for which status is being monitored.
_UserStatus-State	The state the utility is in. See Table 25–43 for descriptions of utility states.
_UserStatus-Target	The end value of the counter (if known).
_UserStatus-UserId	User number.

Table 25–43: _UserStatus-State descriptions

_UserStatus-State value	Utility	Description
11	PROUTIL	Attempting to get a table lock.
12	PROUTIL	Attempting to get an administration lock.
13	PROUTIL	Attempting to lock a storage object.
24	PROUTIL TABLEMOVE	Copying records from one area to another.
25	PROUTIL TABLEMOVE	Creating a new, alternate index.
26	PROUTIL TABLEMOVE	Removing records from the source area after copying from source to target.
27	PROUTIL TABLEMOVE	Removing old indexes.
31	PROUTIL IDXMOVE	Creating a new index.
32	PROUTIL IDXMOVE	Removing old index.
41	PROUTIL IDXCOMPACT	Scanning the index delete chain.
42	PROUTIL IDXCOMPACT	Compacting a non-leaf index block.
43	PROUTIL IDXCOMPACT	Compacting a leaf index block.
51	PROUTIL IDXFIX	Scanning the record manager blocks in a database.
52	PROUTIL IDXFIX	Scanning the index blocks.
53	PROUTIL IDXFIX	Comparing index dbkeys for chosen indexes.
54	PROUTIL IDXFIX	Building the target indexes from the source index.
55	PROUTIL ENABLELARGEFILES	Performing an operation on a binary large object (BLOB).
60	PROBKUP	Initializing area descriptors.
61	PROBKUP	Backing up active before-image clusters.
62	PROBKUP	Estimating size of backup files.
63	PROBKUP	Flushing the buffer pool and before-image buffers.
64	PROBKUP	Backing up area object blocks.
65	PROBKUP	Backing up the before-image file.
66	PROBKUP	Backing up the database blocks per area.
70	PROUTIL DBANALYS	Examining the record manager chain.
71	PROUTIL DBANALYS	Examining the index delete chain.
72	PROUTIL DBANALYS	Examining the free chain.
73	PROUTIL DBANALYS	Examining each database block.
74	PROUTIL DBANALYS	Gathering fragmentation statistics.
80	PROUTIL DUMP	Validating user input.
81	PROUTIL DUMP	Validating column index.
82	PROUTIL DUMP	Validating column data type.
83	PROUTIL DUMP	Dumping records from the specified table using the specified index.
90	PROUTIL IDXMOVE	Validating user input.
91	PROUTIL IDXMOVE	Validating target area.
92	PROUTIL IDXMOVE	Attempting to get a table lock.
93	PROUTIL IDXMOVE	Moving the index blocks from source to target areas.
100	PROUTIL IDXFIX	Creating new indexes for schema index rebuilds.
101	PROUTIL IDXFIX	Scanning all blocks with index blocks of interest.
102	PROUTIL IDXFIX	Scanning all blocks with index or record manager blocks of interest.
103	PROUTIL IDXFIX	Scanning all blocks to reconstruct the indexes.
104	PROUTIL IDXFIX	Rebuilding indexes from the sort files.
105	PROUTIL IDXFIX	Activating every rebuilt index.
106	PROUTIL IDXFIX	Deleting old schema indexes.
110	PROUTIL TABLEMOVE	Validating user input.
111	PROUTIL TABLEMOVE	Validating target area.
112	PROUTIL TABLEMOVE	Attempting to get a table lock.
113	PROUTIL TABLEMOVE	Looking for inactive indexes.
114	PROUTIL TABLEMOVE	Deleting template record from source area.
115	PROUTIL TABLEMOVE	Moving table from source to target area.
116	PROUTIL TABLEMOVE	Creating template record in target area.